System Properties

Overview

The properties file is used to control specific functionality in the Oracle Insurance Rule Workbench (OIRW) application. This file contains specific functions and values. You will need to insert the proper values for the application to perform as desired.

Customer Support

If you have any questions about the installation or use of our products, please visit the My Oracle Support website: https://support.oracle.com, or call (800) 223-1711 Oracle customers have access to electronic support through My Oracle Support. For information, visit http://www.oracle.com/pls/topic/lookup?ctx=acc&id=info or visit http://www.oracle.com/pls/topic/lookup?ctx=acc&id=trs if you are hearing impaired.

Palette Microservice (config.yaml)

Properties

Mandatory Data Type Format Size Default

Allowed Values

Usage detail

com.oracle.insurance.palette.restclients.ReleaseManagement/mp-rest/url YES AlphaNumeric URL <=255 http://localhost:${rm-port} http://<HostName>:${rm-port} This is the internal URL of the Release Management Service. Palette Service will use this URL to communicate with RM Service. You can provide either a private IP address or a container ID here.
frontend.url YES AlphaNumeric URL <=255 http://${public-host}:${frontend-port} http://${public-host}:${frontend-port} The URL of Palette-UI to which users are redirected after authentication.
authenticationType YES Alphabetic   Fixed List basic basic/idcs Supported authentication types: basic, idcsEnsure that the security file in the conf folder follows the naming format: '{authenticationType}-security.yaml'
session.timeout YES Positive Integer nnnnn   3000   Set the session expiration timeout in seconds
javax.sql.DataSource.central.dataSourceClassName YES  Alphabetic   Fixed List  

Oracle: oracle.jdbc.pool.OracleDataSource

DB2: com.ibm.db2.jcc.DB2Driver

SQL Server: com.microsoft.sqlserver.jdbc.SQLServerDataSource

ATP: oracle.jdbc.pool.OracleDataSource

Properties for the central data source (Rules Workbench schema).

(For DB2, the DataSource class name corresponds to the driver class name, which is com.ibm.db2.jcc.DB2Driver)

javax.sql.DataSource.central.dataSource.url YES AlphaNumeric DB URL    

Oracle: jdbc:oracle:thin:@<host>:<port>:<SID>

DB2: jdbc:db2://<host>:<port>/<databasename>:currentSchema=<schema>;

SQL Server: jdbc:sqlserver://<host>:<port>;databaseName=<databasename>;

ATP : jdbc:oracle:thin:@<Service Name>?TNS_ADMIN=<Path to wallet files>

Specify the JDBC URL for the database schema.

 

 

Example for ATP : jdbc:oracle:thin:@atpv12_tp?TNS_ADMIN=/scratch/oipa/OIRW/palette/atp/Wallet_ATPV12x

javax.sql.DataSource.central.dataSource.user YES  Alphabetic       <Username> Username for the database schema
javax.sql.DataSource.central.dataSource.password YES  Alphabetic       <Password> Password for the database schema
public-host YES AlphaNumeric

URL

HostName

    <Host Name/IP> Enter the host name or IP address of the server
frontend-port YES Positive Integer URL Port Number     <Host Port> Specify the server host’s port number for the Palette UI Service.
frontend-https-port YES Positive Integer URL Port Number     <Host Port> Specify the server host’s HTTPS port number for the Palette UI Service. (If its HTTPS)
rm-port YES Positive Integer URL Port Number     <Host Port> Specify the server host’s port number for the Release Management Service.
rm-https-port YES  Positive Integer

URL Port

Number

    <Host Port> Specify the server host’s HTTPS port number for the Release Management Service. (If its HTTPS)
self-port YES  Positive Integer URL Port Number     <Host Port> Specify the server host’s port number for the Palette Service.
self-https-port YES  Positive Integer

URL Port

Number

    <Host Port> Specify the server host’s HTTPS port number for the Palette Service. (If its HTTPS)
csp.policy YES Alphabetic

  default-src 'self'; script-src 'self'; style-src 'self'; img-src 'self'; object-src 'none'; font-src 'self' default-src 'self'http://localhost:8000https://static.oracle.com; script-src 'self' 'unsafe-inline' 'unsafe-eval'http://localhost:8000https://static.oracle.com; Control which sources of content (such as scripts, styles, images, etc.) are permitted to load or execute within the application, helping to protect against cross-site scripting (XSS) and other code injection attacks.
security:hsts:max-age YES

Positive

Integer

nnnnnnnn

  31536000 31536000 The duration (in seconds) that browsers should remember a site as only accessible via HTTPS. Protect users from certain types of man-in-the-middle attacks by ensuring that future requests are automatically upgraded from HTTP to HTTPS for the specified period.
security:hsts:include-sub-domains YES Boolean

  true true/false This ensures that all HTTP requests to the domain and any subdomains are automatically upgraded to HTTPS.
security:hsts:preload YES Boolean

  true true/false Enable HSTS preloading only after you’re sure all subdomains are accessible via HTTPS, as preloading is difficult to reverse and affects all visitors immediately
wallet.location NO AlphaNumeric

    /opt/oracle/atp_wallet/ Specifies the base directory path where the Oracle Autonomous Database (ATP) wallet files are stored on the runtime system
oirw.ai.features.enabled NO

Boolean

  false true/false Controls whether AI-assisted features are available in the application.Default: falseWhen set to true, the application enables AI capabilities. when set to false, disables AI features, and any AI-related endpoints/services.
oirw.ai.base.url NO

AlphaNumeric

URL

  http://localhost:8080/insurance-ai http://<hostname>:<port>/insurance-ai Base URL of insurance-ai
oirw.ai.generate.endpoint NO

AlphaNumeric

Path

  /v1/services/generate /v1/services/generate Generate endpoint
oirw.ai.connect.timeout YES

Positive

Integer

nn

  30   HTTP client timeouts (seconds) Connect timeout: time to establish TCP connection
oirw.ai.read.timeout YES

Positive

Integer

nn

  60   Read timeout: total time to wait for response (LLM calls can be slow)
oirw.enable.debugService  YES

Boolean

  true true/false To enable debug service set to true, Otherwise false (defaults to false)
app.external.base-url YES

AlphaNumeric

URL

  https://<Domain Name>   Base URL for palette service, where internal target call with a hostname that matches the certificate’s SAN, or with a configured external URL
oirw.application.mode NO

Char

  DEVELOPMENT DEVELOPMENT/PRODUCTION Application mode can be set to either DEVELOPMENT or PRODUCTION. This setting is optional and is used with the Schema API to add or update schemas for rule validations against the schema in DEVELOPMENT mode.

Release Management Microservice (config.yaml)

Properties

Mandatory Data Type Format Size Default

Allowed Values

Usage detail

com.oracle.insurance.rm.restclients.PaletteService/mp-rest/url YES AlphaNumeric URL <=255 http://localhost:${palette-port} http://<HostName>:${rm-port} This is the internal URL of the Palette Service. Release Management Service will use this URL to communicate with Palette Service. You can provide either a private IP address or a container ID here.
authenticationType YES Alphabetic   Fixed List basic basic/idcs Supported authentication types: basic, idcsEnsure that the security file in the conf folder follows the naming format: '{authenticationType}-security.yaml'
javax.sql.DataSource.central.dataSourceClassName YES  Alphabetic   Fixed List  

Oracle: oracle.jdbc.pool.OracleDataSource

DB2: com.ibm.db2.jcc.DB2Driver

SQL Server: com.microsoft.sqlserver.jdbc.SQLServerDataSource

Properties for the central data source (Rules Workbench schema).

(For DB2, the DataSource class name corresponds to the driver class name, which is com.ibm.db2.jcc.DB2Driver)

javax.sql.DataSource.central.dataSource.url YES AlphaNumeric DB URL    

Oracle: jdbc:oracle:thin:@<host>:<port>:<SID>

DB2: jdbc:db2://<host>:<port>/<databasename>:currentSchema=<schema>;

SQL Server: jdbc:sqlserver://<host>:<port>;databaseName=<databasename>;

ATP : jdbc:oracle:thin:@<Service Name>?TNS_ADMIN=<Path to wallet files>

Specify the JDBC URL for the database schema.

 

 

 

 

Example for ATP : jdbc:oracle:thin:@atpv12_tp?TNS_ADMIN=/scratch/oipa/OIRW/palette/atp/Wallet_

javax.sql.DataSource.central.dataSource.user YES  Alphabetic       <Username> Username for the database schema
javax.sql.DataSource.central.dataSource.password YES  Alphabetic       <Password> Password for the database schema
palette.baseUrl YES AlphaNumeric URL <=255 http://${public-host}:${palette-port} http://${public-host}:${palette-port} The URL for Palette Service to which users are redirected and form the reference links.
public-host YES AlphaNumeric

URL

HostName

    <Host Name/IP> Enter the host name or IP address of the server
frontend-port YES Positive Integer URL Port Number     <Host Port> Specify the server host’s port number for the Palette UI Service.
frontend-https-port YES Positive Integer URL Port Number     <Host Port> Specify the server host’s HTTPS port number for the Palette UI Service. (If its HTTPS)
palette-port YES Positive Integer URL Port Number     <Host Port> Specify the server host’s port number for the Palette Service.
palette-https-port YES Positive Integer URL Port Number     <Host Port> Specify the server host’s HTTPS port number for the Palette Service. (If its HTTPS)
self-port YES  Positive Integer URL Port Number     <Host Port> Specify the server host’s port number for the Release Management Service.
self-https-port YES  Positive Integer

URL Port Number

    <Host Port> Specify the server host’s HTTPS port number for the Release Management Service. (If its HTTPS)
csp.policy YES Alphabetic

  default-src 'self'; script-src 'self'; style-src 'self'; img-src 'self'; object-src 'none'; font-src 'self' default-src 'self'http://localhost:8000https://static.oracle.com; script-src 'self' 'unsafe-inline' 'unsafe-eval'http://localhost:8000https://static.oracle.com; Control which sources of content (such as scripts, styles, images, etc.) are permitted to load or execute within the application, helping to protect against cross-site scripting (XSS) and other code injection attacks.
security:hsts:max-age YES

Positive

Integer

nnnnnnnn

  31536000 31536000 The duration (in seconds) that browsers should remember a site as only accessible via HTTPS. Protect users from certain types of man-in-the-middle attacks by ensuring that future requests are automatically upgraded from HTTP to HTTPS for the specified period.
security:hsts:include-sub-domains YES Boolean

  true true/false This ensures that all HTTP requests to the domain and any subdomains are automatically upgraded to HTTPS.
security:hsts:preload YES Boolean

  true true/false Enable HSTS preloading only after you’re sure all subdomains are accessible via HTTPS, as preloading is difficult to reverse and affects all visitors immediately
wallet.location NO AlphaNumeric

    /opt/oracle/atp_wallet/ Specifies the base directory path where the Oracle Autonomous Database (ATP) wallet files are stored on the runtime system
releasePackage.tempDir YES

AlphaNumeric

    /scratch/oipa/OIRW/rm/temp Complete path of the temporary directory used for release package.
releasePackage.downloadDir YES

AlphaNumeric

    /scratch/oipa/OIRW/rm/download Complete path of the download directory used for release package.
wallet.location NO AlphaNumeric

    /opt/oracle/atp_wallet/ Specifies the base directory path where the Oracle Autonomous Database (ATP) wallet files are stored on the runtime system
migration.batch.threshold.records NO

Positive Integer

  2000 >=2000 These properties are used to split large datasets into smaller batches/chunks, helping reduce network latency and improve migration performance.During migration, the system switches from single-call processing to batch mode once the total number of records exceeds the configured threshold limit.
migration.batch.max.records NO Positive Integer

  500 >=500 Defines the maximum number of records that can be processed in a single batch request.

Rule Workbench UI service (.env)

Properties

Mandatory Data Type Format Size Default

Allowed Values

Usage detail

PALETTE_URL YES AlphaNumeric URL <=255 http://localhost:8080/ http://<public-host>:<palette-port>/ The endpoint URL for the Palette Service, accessible by the UI.
RM_URL YES AlphaNumeric URL <=255 http://localhost:8081/ http://<public-host>:<rm-port>/ The endpoint URL for the Release Management Service, accessible by the UI.
AUTHENTICATION_TYPE YES Alphabetic   Fixed List basic basic/idcs

Authentication types supported: basic, idcs. This property defines the authentication mechanism used by the application.

VERSION_NUMBER YES Alphabetic     1.0.0.0 1.0.0.0 Specifies the version of the system.
PRIVATEKEY_FILE YES AlphaNumeric Path   /<filepath>/privatekey.pem   Specifies the private key file name with an absolute path.
CERTIFICATE_FILE YES AlphaNumeric Path   /<filepath>/certificate.pem   Specifies the certificate file name with an absolute path.
CA_FILE NO AlphaNumeric Path   /<filepath>/ca_bundle.pem   Specifies the CA bundle file with an absolute path, and it's optional.